package com.kwdata.quartz.param;

public class ResponseParam {

    public static final String res = "{\n" +
            "    \"code\": 200,\n" +
            "    \"msg\": \"操作成功\",\n" +
            "    \"data\": [\n" +
            "        {\n" +
            "            \"birthday\": \"1981-03-21 00:00:00\",\n" +
            "            \"patientno\": \"\",\n" +
            "            \"nurselevel\": \"\",\n" +
            "            \"nation\": \"-1\",\n" +
            "            \"ageunit\": \"周岁\",\n" +
            "            \"rytj\": \"1\",\n" +
            "            \"sex_code\": \"1\",\n" +
            "            \"main_cable_no\": \"2962193520\",\n" +
            "            \"zyzd\": \"2型糖尿病\",\n" +
            "            \"mzzdbm\": \"E11.900\",\n" +
            "            \"bedno\": \"\",\n" +
            "            \"ryks\": \"内分泌门诊\",\n" +
            "            \"visitno\": \"\",\n" +
            "            \"height\": \"\",\n" +
            "            \"profession\": null,\n" +
            "            \"cysj\": \"2023-12-01 14:58:58\",\n" +
            "            \"mzzd\": \"2型糖尿病\",\n" +
            "            \"zyzdbm\": \"E11.900\",\n" +
            "            \"weight\": \"\",\n" +
            "            \"rysj\": \"2023-12-01 14:31:21\",\n" +
            "            \"patientname\": \"徐鑫\",\n" +
            "            \"cyks\": \"内分泌门诊\",\n" +
            "            \"phone\": null,\n" +
            "            \"idcard\": \"150426198103213231\",\n" +
            "            \"hospital_code\": \"0002\",\n" +
            "            \"encnt_no\": \"7927723\",\n" +
            "            \"ylfkfs\": \"02\",\n" +
            "            \"org_code\": \"42017976-4\",\n" +
            "            \"age\": null,\n" +
            "            \"outpat_no\": \"0000636421\"\n" +
            "        },\n" +
            "        {\n" +
            "            \"birthday\": \"1981-03-21 00:00:00\",\n" +
            "            \"patientno\": \"\",\n" +
            "            \"nurselevel\": \"\",\n" +
            "            \"nation\": \"01\",\n" +
            "            \"ageunit\": \"周岁\",\n" +
            "            \"rytj\": \"1\",\n" +
            "            \"sex_code\": \"1\",\n" +
            "            \"main_cable_no\": \"2962193520\",\n" +
            "            \"zyzd\": \"2型糖尿病\",\n" +
            "            \"mzzdbm\": \"E11.900\",\n" +
            "            \"bedno\": \"\",\n" +
            "            \"ryks\": \"内分泌门诊\",\n" +
            "            \"visitno\": \"\",\n" +
            "            \"height\": null,\n" +
            "            \"profession\": \"C9\",\n" +
            "            \"cysj\": \"2023-12-01 14:58:58\",\n" +
            "            \"mzzd\": \"2型糖尿病\",\n" +
            "            \"zyzdbm\": \"E11.900\",\n" +
            "            \"weight\": null,\n" +
            "            \"rysj\": \"2023-12-01 14:31:21\",\n" +
            "            \"patientname\": \"徐鑫\",\n" +
            "            \"cyks\": \"内分泌门诊\",\n" +
            "            \"phone\": \"13687271175\",\n" +
            "            \"idcard\": \"150426198103213231\",\n" +
            "            \"hospital_code\": \"0002\",\n" +
            "            \"encnt_no\": \"7927723\",\n" +
            "            \"ylfkfs\": \"02\",\n" +
            "            \"org_code\": \"42017976-4\",\n" +
            "            \"age\": null,\n" +
            "            \"outpat_no\": \"0000636421\"\n" +
            "        }\n" +
            "    ],\n" +
            "    \"actualSql\": \"select distinct \\n cs.main_cable_no,\\n cs.org_code,\\n cs.hospital_code,\\n cs.encnt_no, -- 就诊流水号\\n cs.outpat_no,\\n cs.inpatient_no as patientno,\\n '' as visitno,\\n cs.ylfkfs,\\n pat.patient_name as patientname,\\n (case when age = '0'  and age_month = '0' then age_day\\n when age = '0'  and age_month > '0' then  age_month\\n else age end) as age,\\n (case when age = '0'  and age_month = '0' then '天'\\n when age = '0'  and age_month > '0' then '月'\\n else '周岁' end)  as ageunit,\\n '' as bedno,\\n pat.person_id as idcard,\\n pat.birth_date as birthday,\\n pat.sex_code,\\n cs.pat_type_code as rytj,\\n cs.inhosp_dt as rysj,\\n cs.jzksmc as ryks,\\n cs.discharge_date_time as cysj,\\n cs.jzksmc as cyks,\\n cs.diag_name as mzzd,\\n cs.diag_code as mzzdbm,\\n cs.diag_name as zyzd,\\n cs.diag_code as zyzdbm,\\n '' as nurselevel,\\n pat.height,\\n pat.weight,\\n pat.ethnic_group_code as nation,\\n COALESCE(pat.phone_tel,mobile_tel) as phone,\\n pat.occup_type_code as profession\\n from dwd_lcyl_cdr_case_summary cs,\\ndwd_lcyl_cdr_pat_infotest pat\\n WHERE  cs.main_cable_no = pat.main_cable_no\\t\\n \\nAND cs.main_cable_no = ?\\n \\n \\nAND cs.inhosp_dt >= ? \\n  LIMIT 0,10\",\n" +
            "    \"requestParams\": {\n" +
            "        \"main_cable_no\": \"2962193520\",\n" +
            "        \"start_date\": \"2023-11-01 00:00:00\",\n" +
            "        \"end_date\": \"2023-12-31 23:59:59\",\n" +
            "        \"offset\": \"0\",\n" +
            "        \"rowNum\": \"10\"\n" +
            "    },\n" +
            "    \"pagination\": null\n" +
            "}";
}
